SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200951 LIMIT 1 [ RunTime:0.000446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200951 [ RunTime:0.001850s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426950,807599,432920,330696,717008,136568,58608,905838,40771,703609,307802,243004,494474,33773,931086,50994,812054,279962,450356,1035821,478078,259625,423491,93169,864905,46928,751618,115405,445723,831950,946490,686763,92955,996169,966253,269739,221915,365337,387249,313513,187477,338307,840771,110481,359304,931736,382069,238971,81459,141923,1015877,514,42451,595798,39275,227577,946614,998578,1013589,418603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200951 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200951 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]