SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002480s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 443923 LIMIT 1 [ RunTime:0.002110s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 443923 [ RunTime:0.002191s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420514,836188,579666,89463,293712,360878,213245,684067,389067,306052,617779,92029,227458,486800,795449,606710,798811,842353,319395,113853,622604,292125,354816,394061,26062,644258,335411,422929,142062,190856,240402,96620,58773,781519,999314,359769,972961,775360,92666,956589,280058,81960,49472,470191,228876,193421,74933,225421,967502,507144,668532,808506,179763,997146,420227,20733,548446,98820,68794,945057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 443923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 443923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001273s ]