SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107958 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107958 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (672524,302808,404017,503857,647786,567907,342357,324607,289330,189694,103524,834909,567537,634352,119240,554147,930448,271879,1024759,633407,883869,255698,863275,518903,1985,942631,772560,523061,988342,1000279,739382,186598,837956,432247,318482,781373,972577,1006441,710399,888045,277351,766400,314012,331548,527371,565377,930941,757298,797514,205106,772810,883520,947785,550471,575256,871757,406598,55218,930911,104365) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107958 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107958 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]