SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510946 LIMIT 1 [ RunTime:0.001101s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510946 [ RunTime:0.003359s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269333,258808,263837,480037,3438,332716,261790,208502,145800,863079,209593,273245,319961,765299,621677,620817,533480,460008,148404,892568,51896,334415,466066,105541,830518,837766,465384,372483,12535,151312,351937,743249,18025,199605,953883,59404,592887,990001,445379,168035,639220,70210,135686,88472,14951,393462,394136,98953,552404,299948,58374,635892,472272,852116,110828,607951,244888,960238,995709,275211) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510946 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510946 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]