SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292180 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292180 [ RunTime:0.001598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (223155,426233,48326,993777,1046829,987088,717747,704225,431227,666062,107801,871443,489332,982111,924757,183569,37958,667700,842896,350364,997319,850125,583827,910120,375509,563189,456408,787481,116655,468928,218271,44064,206080,111347,180710,241941,273622,177477,835981,301466,58828,213837,412994,707588,313105,718421,395128,372518,363126,304916,60342,990718,752122,675621,991482,680928,851859,624263,524500,402452) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000940s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]