SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039209 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039209 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (442690,913597,867545,107500,726611,92051,626714,368560,668905,101535,986486,34805,4040,729409,467238,586204,129620,313342,299715,514466,882258,712081,221874,745750,636449,438027,245853,1006965,510026,875825,106183,240565,38058,607857,752618,670214,930293,775330,8977,284148,78106,453312,324757,366332,329748,817264,55796,530699,732622,401033,1030092,325431,767984,232304,4494,462902,375188,862696,925827,112777) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]