SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548191 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548191 [ RunTime:0.001897s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (772316,581166,817475,684482,160946,524799,871016,278031,212179,416000,846778,829476,950261,578790,156648,1010824,564832,683966,838107,597667,406057,598680,81109,900762,548596,376376,905755,513881,407796,243771,1014264,871507,522947,198868,673017,212826,752811,996191,1037685,689103,623634,754897,1640,202675,154286,822056,112932,31161,674036,51865,239318,472099,510040,248829,1036126,506682,1000558,106767,646955,134065) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]