SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001896s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547048 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547048 [ RunTime:0.006335s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (641316,528987,588715,258687,844384,301723,108718,460640,277216,315145,260381,886809,495245,543060,657161,29061,94110,897014,298464,816038,454693,284699,969284,630416,755680,998504,522640,851341,214910,81952,587183,528132,537219,88321,859500,557873,812351,1785,353203,1015039,264668,988938,338465,558937,883336,70333,319276,162749,494961,370151,1004292,613056,160178,946062,412018,334703,98706,830283,1006077,650313) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000616s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]