SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518715 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518715 [ RunTime:0.001674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (342815,60941,688542,901484,593169,1000709,989653,555323,1027607,1019872,256177,411203,514867,32951,683032,605476,392358,812608,165704,582966,144642,780796,564090,309896,4127,597973,78241,441004,24090,704709,509374,721684,810909,658605,653620,617336,1047153,128697,839581,66151,691565,884044,944597,383843,212738,851,56245,696439,640066,579749,846544,58097,941000,631187,789757,883985,835927,677727,301539,739376) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518715 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518715 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]