SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570571 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570571 [ RunTime:0.001528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411767,1021220,429895,332591,721954,731676,71569,417683,570120,447017,169391,1000897,509670,434814,994473,951280,662294,219233,867890,200901,653700,572785,172872,418479,855234,987765,1017283,84712,291964,1015868,774670,341247,269213,278078,424635,773665,581966,973295,164989,334966,433419,447477,658619,632818,560789,233125,291176,130430,611586,955330,859822,1045923,719323,687227,305251,364410,234991,578065,486835,722505) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000998s ]