SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328576 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328576 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (160259,510662,293856,964710,501645,71265,865176,1047041,181446,183962,507034,385524,585448,352169,270982,116356,405641,373848,56807,852272,573916,351594,522894,880594,499782,952856,577060,903822,589376,233365,773169,496644,721237,426300,696149,933377,31859,566388,864326,33883,136828,906637,612374,829236,963551,159131,979857,103973,881081,526351,2284,874216,446230,574128,411651,883305,184068,823797,791528,45326) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328576 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328576 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]