SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001768s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431617 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431617 [ RunTime:0.002177s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (369489,539942,991120,578670,902489,278404,128558,239485,617299,201052,259594,316178,858940,903090,500527,641424,567793,566469,1012487,351837,707439,191814,791754,541701,924871,423675,439700,317100,331364,772912,184546,958160,810818,532676,162664,941571,126530,502517,527501,386464,644853,328047,1038488,762414,937807,929333,240979,625528,773629,765919,121732,345400,459510,708971,925840,572318,180877,83005,637878,383770) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431617 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431617 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]