SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106263 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106263 [ RunTime:0.002202s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (713704,80164,658914,287156,140825,874460,177862,241730,372386,747270,731651,308838,193431,252012,868671,97868,308114,69022,184697,677426,716342,474919,1031470,914619,764660,897360,1005681,570290,719226,289737,354379,246580,916517,141821,201029,867078,601462,917390,179572,1030498,714468,51161,797273,545683,752732,950808,194026,468151,1038962,398339,4868,81173,295503,580152,969214,469807,467195,187922,995542,569341) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106263 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106263 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]