SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 493389 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 493389 [ RunTime:0.001611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447104,772256,200861,956848,660894,1028509,1020129,156678,577503,808716,779426,395223,620540,860937,839941,876074,916945,34390,315897,613244,171721,160191,100962,159664,665591,177889,781534,517698,405952,889940,618976,580877,746959,823374,537116,101440,739446,442000,766336,261946,394310,722840,699546,323179,472440,406630,922749,935007,106723,1036308,931143,827846,906213,619554,931438,678058,637936,529230,577489,773831) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 493389 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 493389 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]