SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432929 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432929 [ RunTime:0.002110s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812399,1041628,944802,910146,831089,1041961,890732,613534,272029,63680,587136,448910,92906,695895,421414,675811,660799,870676,661624,45242,30144,371547,968664,140408,405998,118932,753886,968487,16160,685397,57344,579582,928026,521786,909407,267223,695363,690069,385022,632411,688155,717741,59263,81861,600295,218812,1023388,723037,593188,852618,975832,966648,240651,699316,532725,905280,192184,137467,602912,109382) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432929 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432929 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]