SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 772012 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 772012 [ RunTime:0.002181s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404551,147081,1043113,493948,290615,576122,726521,43487,309221,470203,408100,440687,13612,69521,713513,968962,459402,567918,325013,258387,119613,148724,878655,86994,463482,368986,234496,197069,880933,558237,679416,16103,789166,821732,51640,644359,209675,332746,102307,469406,384684,152563,626382,733963,477539,966988,414713,1002856,550615,401602,2557,337054,916620,642902,591154,857080,990815,846694,131606,896303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 772012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 772012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]