SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 125013 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 125013 [ RunTime:0.001593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415880,879433,582775,420826,317117,697897,677945,125281,1009101,1040913,805094,731046,378525,171110,1041069,162254,953406,460282,293590,290047,79620,17739,31549,857802,880976,342803,852936,566871,989627,252796,440854,6215,916163,674640,718913,790013,403528,422328,89497,931004,589925,851862,444070,214870,578248,662923,501012,997026,111758,417783,1028603,252808,95691,198633,331255,630543,41985,405391,132729,325423) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 125013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 125013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]