SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001832s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 323686 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 323686 [ RunTime:0.001954s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (493787,209291,167901,105050,904594,447386,1013647,222936,512176,977483,271491,468306,78335,302121,672323,481511,921742,76085,919571,986918,673163,961424,40607,979159,442044,344395,114713,977526,655269,1047350,296158,389191,371102,816872,181575,639009,974409,676880,927747,366829,238248,105028,1013677,961,357208,1040449,209935,184035,767075,464681,971427,731062,192097,930866,146800,858586,281026,903279,276240,964796) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 323686 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 323686 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]