SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004557 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004557 [ RunTime:0.003407s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (930676,61709,947810,813853,659427,885589,122716,112088,873411,233014,751191,283053,544001,644658,58016,643610,16965,94682,517827,677383,56462,32485,569762,852374,1027439,500383,618396,988520,340947,1037426,934784,13179,278071,803346,696246,965932,965584,1047934,483738,266719,343408,745337,790121,613336,886628,811112,910630,603243,360812,777012,212416,285390,417617,983485,420353,1018869,335885,212280,19844,601885) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003779s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004557 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004557 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002933s ]