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` = 675183 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 675183 [ RunTime:0.002015s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (130706,274357,758028,622845,944577,395893,516858,603863,96839,261844,108278,340077,144711,761666,211036,997380,288679,703149,399523,382170,751067,138407,990203,278552,190242,481372,1012244,1016796,265985,715772,871138,409257,711774,436057,1030177,4058,378557,626670,693992,546529,172844,597442,240930,312944,32121,6241,145294,618567,676110,962887,990215,280593,654549,385246,945514,400332,532441,184366,725371,950396) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 675183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 675183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001421s ]