SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001440s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803206 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803206 [ RunTime:0.003609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317098,916792,956580,872811,639973,823431,822601,992109,812250,825084,644283,419592,118460,229986,1041170,377299,989677,646493,664165,455200,505341,16596,187739,425003,768173,710931,207041,579894,879746,713605,498815,89790,127341,1026839,417684,703635,530899,964960,155396,334931,258955,248607,1040075,881471,967742,251601,122603,405106,447175,1001755,1006669,96366,814463,1014860,640387,567263,481424,367149,3436,330393) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001649s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803206 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803206 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]