SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111312 LIMIT 1 [ RunTime:0.000282s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111312 [ RunTime:0.001450s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317282,352760,219590,677764,78287,351485,84652,528807,852470,61669,746471,559086,963405,225197,88727,654418,888698,1019793,430724,63865,35762,198130,1036105,98777,215779,635267,36492,110833,398536,845543,1015037,637577,105957,782270,1041588,151242,326919,860744,58879,792136,723902,251980,60394,988410,132412,165351,994935,514593,40188,656519,664218,945359,880141,535407,983432,701367,920584,216052,301218,412489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]