SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801613 LIMIT 1 [ RunTime:0.000485s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801613 [ RunTime:0.001916s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (683742,1003496,598601,314637,153940,331916,123131,124818,374284,23566,519650,918558,754263,729672,415843,280105,982337,445157,618191,181558,383719,706857,849943,175065,71200,372848,472232,73805,689879,910444,384292,191045,355106,540796,931972,306220,311674,151594,497395,232170,898507,167474,322047,39310,794703,891564,850171,772505,235165,930636,560860,629115,431754,636337,183782,349133,191574,41243,192991,981406) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]