SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042118 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042118 [ RunTime:0.001937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101467,351180,517543,504627,507983,988508,442176,93637,256087,117201,563920,946143,560576,328345,157792,119245,710977,341886,72414,8083,563780,98893,657132,953379,869654,325057,576304,103521,869859,561638,844250,385488,638342,633660,712973,306117,123040,26610,1001281,860772,961987,936485,182127,417315,677901,5416,971999,438037,284721,693991,116731,690762,215706,668167,293524,1014317,268349,47154,58514,600446) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]