SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001611s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204767 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204767 [ RunTime:0.001645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (851148,65926,490601,478472,1008916,936880,890336,156156,772080,393470,486866,867637,486123,114220,133413,220026,378482,850731,129441,325472,316137,953318,909193,179454,479895,452840,970258,578556,896203,654993,710085,215157,19720,648955,952960,657677,453890,262185,102062,175930,959181,365868,483428,793627,611817,100884,421643,770749,581658,185637,851175,312489,332006,336452,560474,764273,759798,344650,254202,527283) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204767 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204767 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]