SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001549s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420857 LIMIT 1 [ RunTime:0.001290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420857 [ RunTime:0.004965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (958452,375182,501775,665506,260159,963921,869110,947588,525538,286502,398778,21314,511261,844871,432423,186847,398085,232731,712940,652178,601406,771042,383259,873585,229601,28578,523502,336340,897419,346801,48645,459931,941389,376289,653923,732188,276896,1005154,997089,693886,914534,270921,283698,803316,412222,542976,388250,982347,606855,434798,210515,655820,931512,548043,133863,672126,705486,455771,507390,1033599) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420857 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420857 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]