SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001641 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001641 [ RunTime:0.001469s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (441685,658991,171160,375641,525032,104303,720427,896143,246786,554814,435138,439803,152229,832021,713511,160885,170371,88066,786610,515714,118543,1043432,4690,751235,553433,407059,634216,952077,777386,449402,1017037,119246,542694,788794,1040470,868880,259311,731613,534683,907225,549935,112490,98381,593137,686213,897883,896496,91921,929971,885022,614720,698418,163194,965001,676766,761963,525054,357037,813710,38619) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001641 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001641 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000408s ]