SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 303104 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 303104 [ RunTime:0.002628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459785,612560,846836,464177,138590,347477,985929,547025,968049,867013,516954,859598,324349,89,650994,639248,100221,811656,34459,431167,334886,615552,838754,604330,236417,915423,674331,754714,427063,179882,859912,608795,325601,258111,317199,888056,377199,917820,664852,591809,757536,862110,292007,358385,595558,801522,1004753,765541,476654,465100,855607,877229,171192,956377,42016,556123,562825,608080,33316,248328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 303104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001733s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 303104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]