SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486993 LIMIT 1 [ RunTime:0.001195s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486993 [ RunTime:0.002295s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (54521,644725,505393,442150,862111,290073,583645,848501,96950,390995,293009,789199,624732,741761,608884,91198,826260,701187,561314,491550,561336,555750,678875,384313,257601,941469,893424,93485,804514,1861,124549,137510,945971,368302,58139,445659,96865,581404,222876,603155,321788,546077,15569,195482,762594,502886,27851,421804,957361,792727,464816,756143,988367,846579,386748,508744,788242,1025913,973049,768962) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006870s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000682s ]