SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001595s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506178 LIMIT 1 [ RunTime:0.000589s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506178 [ RunTime:0.002648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28307,218491,299464,491524,881906,806655,10612,736899,195289,164898,560266,491736,647774,931090,278710,104193,348479,214389,173274,1001394,373827,755687,504180,80937,496740,370192,468348,574720,701794,344285,623298,729815,572378,741858,975939,278977,1004928,198848,78971,56944,774895,688113,49445,461317,937750,41322,155803,504832,181689,6543,58367,740786,648671,473123,203755,726657,327231,284923,904284,391606) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001601s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000830s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001150s ]