SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504201 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504201 [ RunTime:0.003176s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (993149,334351,101010,581642,23559,895203,544367,479540,216719,43858,462986,468092,887069,211403,26967,5254,122378,443550,647333,154761,670452,924727,397056,743188,123207,16021,629668,819974,1033791,308619,451039,272238,612051,828319,37919,71065,821143,906701,732017,858499,232381,973582,981051,772706,1009295,404892,730443,54205,870211,628482,91137,397123,826392,649477,819954,888323,226310,599722,971978,822084) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]