SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502686 LIMIT 1 [ RunTime:0.000626s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502686 [ RunTime:0.001843s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (79891,121069,200200,433785,259156,555309,519942,595950,886116,168133,67255,666064,996138,345368,389240,315222,417545,688605,548133,66308,389722,632604,373745,484668,717812,65795,562378,914630,615433,272912,279914,440153,635852,817019,680070,649466,312431,637430,742626,367463,921217,659060,461262,623077,668967,482076,61623,973400,814683,120975,161950,218209,577399,169436,794521,851858,293066,419055,619223,62971) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502686 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502686 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]