SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494496 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494496 [ RunTime:0.006311s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (748953,490790,781136,346603,358839,777422,542042,1025828,938581,98082,905867,377398,881041,574498,262842,27822,455252,450244,815540,875044,947532,318216,646483,505375,377156,483263,605481,998451,800061,710029,381515,424847,18230,64957,325066,137788,367746,420353,70824,1008406,240248,868920,991693,16450,529311,322882,752055,240645,402438,769866,282330,403229,1925,995492,768773,298157,563845,48141,486583,323037) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494496 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494496 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001632s ]