SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429138 LIMIT 1 [ RunTime:0.000571s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429138 [ RunTime:0.005320s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28767,420609,319433,291094,54710,648477,715628,689525,976837,620321,1000279,92439,922279,61524,541019,135509,640361,668773,839511,261738,731429,623879,943925,295868,279089,66173,8968,300439,862432,496255,975147,186993,723793,110479,667708,875717,909389,801519,821157,674848,710439,94141,100436,40487,81742,610761,272579,390219,204809,624659,737371,706766,2166,410245,536859,835062,351383,506618,1012380,560061) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429138 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429138 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]