SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 186896 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 186896 [ RunTime:0.001596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193853,101817,497397,202351,720805,551826,836760,302362,414156,233101,1037703,609185,752934,543780,1025492,991415,519040,395445,208509,602280,330719,384489,833606,946288,519099,745667,331707,1002357,303297,189404,57029,929684,236990,112507,868954,495576,731266,879212,158911,922586,968365,272855,599077,637232,668495,708463,617421,1029555,264131,960344,621503,724603,435787,311708,249624,117131,364334,369908,56728,478228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 186896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 186896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]