SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412081 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412081 [ RunTime:0.001268s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (56508,302538,933603,920617,988565,626244,977010,559025,321436,22582,543885,1044929,623126,882179,261058,1021193,26634,554216,565926,502943,475270,615014,598741,472379,464545,116660,452016,1783,219747,938186,678518,862730,884101,433436,522879,963702,968450,465766,811578,125665,389635,867304,230207,28200,324603,736809,429573,389391,729801,144340,554885,456679,507165,709493,4619,460776,318420,568706,600312,539756) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001496s ]