SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537413 LIMIT 1 [ RunTime:0.000513s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537413 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383826,516303,854840,208019,316030,460521,148800,790590,436850,9119,133278,27657,394596,802646,818477,30546,643342,547974,536207,454089,746330,79047,455201,229403,819524,843321,54336,559962,997388,283427,540356,570384,743405,610878,161439,931390,965681,616873,332295,619226,68768,594802,89965,203236,702874,849487,467227,335195,992187,727049,423259,677357,441400,117047,615830,650594,508705,817466,999463,664913) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]