SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002520s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 683311 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 683311 [ RunTime:0.002398s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (890806,839714,468897,459722,670139,371971,685872,549980,943371,512540,230605,902573,120039,554791,537438,491375,430682,58879,1002720,305374,246805,912356,703839,624115,604304,619922,97461,17270,641535,708167,358631,671516,191785,940711,74047,1045776,295735,602899,671264,689984,59982,811573,20695,324458,815648,39304,475835,47069,178513,545419,999785,218855,1039304,44611,488670,428137,627638,738420,286309,870084) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 683311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 683311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]