SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504366 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504366 [ RunTime:0.001979s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (288172,458616,993844,65996,988586,696925,516975,122864,372676,845493,720757,833090,469992,346213,166793,681361,710178,190849,534328,879580,324303,110500,940804,262997,418185,151850,359233,209720,235604,996945,984564,573649,16424,441753,869601,566280,713535,697684,170617,932395,419420,355027,1029952,1019183,193138,120622,802300,550926,89348,901537,559817,197001,150189,289381,926419,246917,517712,211096,942718,1023153) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504366 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504366 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000991s ]