SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 579272 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 579272 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005767,988284,965631,503476,308199,20929,33829,59998,672922,892808,285797,404219,455029,721682,724172,599465,903278,318214,126242,34331,467389,7862,956549,838979,160359,568426,10172,234800,1040475,930116,48487,339263,52795,967760,740710,792278,313035,984439,555925,713715,872571,1032977,57689,761170,452799,1011939,406416,98787,498494,143685,68395,386372,551823,756833,620597,854110,288628,53015,711327,694340) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 579272 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 579272 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]