SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43152 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43152 [ RunTime:0.001676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (171468,298001,1578,934462,388208,1035599,695811,782309,937560,153898,715435,164838,903715,384249,445889,744915,283267,971997,866363,117025,234539,1027475,981573,140060,298819,398194,511176,189446,542291,1023396,224519,422603,75742,945709,156196,908567,203406,170531,580336,1009897,576449,649904,570168,54571,919420,719972,683075,247266,278184,357607,522818,890729,991642,941635,349238,738784,836988,113502,321884,797035) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43152 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43152 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]