SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417898 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417898 [ RunTime:0.004582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368018,898570,571095,785739,435772,109024,342270,783134,773078,717718,1043649,500207,742496,330014,733766,546333,560571,276392,799296,631704,534508,479546,899704,494879,223588,413062,305698,754432,225503,76021,940585,1011428,32553,938212,945809,557042,546410,298642,755433,314781,420032,190223,5579,417138,771831,385198,942784,799795,116914,142157,404113,131678,42519,318890,737416,481531,761942,609308,308397,615771) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417898 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417898 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]