SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460513 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460513 [ RunTime:0.001835s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (738296,476332,558060,467007,857783,168101,915692,671057,499612,996747,235810,431119,686770,56637,411999,621707,224220,384417,64704,91473,519310,819295,810563,889143,676129,486686,1047160,306670,255968,559556,814599,630805,37013,471017,429209,205099,602684,823048,608841,694007,205526,47428,703376,375452,649096,569707,137501,972527,651440,404965,439307,757655,710337,728443,740958,62597,603145,982142,101771,285567) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]