SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001523s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506918 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506918 [ RunTime:0.003158s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (304282,963193,790058,1045884,31678,582301,60110,518731,876011,624117,793185,598238,449445,52369,710867,671481,1043015,573093,504252,707455,138848,998896,255893,913870,237907,192866,385757,661729,276880,300929,369666,1031467,140750,319557,1000244,695235,244127,992209,222402,987050,312719,266175,473119,375720,297001,930298,1041193,959959,463426,922534,894547,435796,727610,429929,264285,705707,548093,611654,318118,819654) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000747s ]