SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037833 LIMIT 1 [ RunTime:0.000559s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037833 [ RunTime:0.002279s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (192279,631049,846785,702161,807401,137387,574378,152777,299801,729192,831063,72197,678312,723833,363451,652661,210516,926111,194873,607933,512504,1037288,35929,341983,660693,124399,687148,137205,178134,328681,677872,705315,365706,137383,725880,335398,320740,349729,259021,776312,163669,782317,951760,960249,516752,406313,84516,431015,120901,230696,991553,121468,513685,972352,108321,142846,304666,440288,486462,636958) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037833 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037833 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000691s ]