SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013512 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013512 [ RunTime:0.001905s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (129557,1012679,126670,332247,938010,616423,813127,19491,898534,202934,958069,950749,426284,499189,40262,221798,234105,213738,477281,583889,67559,549420,85729,111434,1006386,1039441,832907,355037,933959,52927,789366,1003195,590164,911683,115664,628138,123625,74946,876220,179209,227871,467625,693614,453530,160635,361204,519653,241547,129620,965114,8453,996269,39847,340724,924781,320263,110576,81558,1001690,139389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]