SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004478 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004478 [ RunTime:0.001825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (14527,7915,310120,961353,14014,672263,509253,125626,898862,252133,331255,454323,207414,842197,1033349,841301,600151,811597,970054,438995,505661,890540,659087,893437,988917,407337,475021,262935,6133,995484,672559,1001401,127732,334084,11520,149416,912004,470499,300624,490091,82548,436925,357656,726917,697476,165930,1014551,317255,45907,597505,115796,697489,332508,1037773,257686,472834,9438,190712,940064,908688) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001630s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004478 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004478 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]