SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104404 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104404 [ RunTime:0.002612s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (461051,133957,462329,840580,282558,65927,828576,379459,425235,358433,55416,547051,1037429,311420,856723,809383,520537,557095,785911,498788,563987,989369,566807,698160,536103,1016262,420840,509897,811413,466918,382448,584812,891149,354728,578519,722941,485191,950880,478986,52049,1017967,661419,166112,100181,930667,763061,328685,772704,308681,417548,718630,479838,981223,299789,1036284,192143,510680,223092,964689,855490) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]