SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438504 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438504 [ RunTime:0.003204s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280921,377712,132765,425425,986254,62303,404675,205659,580290,977698,805213,349012,834440,721728,1013453,742095,324093,86544,1018840,308504,664404,654586,356369,730368,29589,478775,391012,1013547,469323,521130,343199,172763,285627,896672,18153,47591,240451,700104,809912,12920,830089,507284,993419,365272,34676,888612,521602,660653,336230,872008,541578,736743,526071,465989,9658,950693,522874,537695,997613,594859) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]