SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514726 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514726 [ RunTime:0.002531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019933,49359,411371,945919,198834,273373,8606,178380,472141,1018159,211878,30657,544845,640908,734618,741393,464855,943323,552981,1016936,667249,87298,584960,860755,126267,884325,568768,818868,293554,123000,893565,618200,666134,885041,850072,455889,544943,718719,475888,596329,394059,529063,678559,159261,628535,236531,368729,286152,357567,911058,612085,4081,402510,369642,287818,499768,658449,111605,579954,637876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001573s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514726 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514726 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001041s ]