SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 448723 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 448723 [ RunTime:0.001638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (684483,24744,634722,1021246,589615,912402,513114,69994,209237,733808,213378,776486,197957,441579,863028,620224,915181,192168,475298,1025376,425831,508729,853776,437274,505455,666172,22970,1028790,38958,1038366,457137,981580,732752,383036,1037488,957290,597030,818417,475469,908609,105416,897210,248242,948222,961029,633816,127662,990874,142996,30824,85331,481521,944523,100335,703307,954622,313663,913383,490869,391510) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 448723 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 448723 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]