SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003540s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804484 LIMIT 1 [ RunTime:0.000514s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804484 [ RunTime:0.002237s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (933561,659842,436924,389829,254607,320158,636654,47223,227592,934701,722239,556546,926250,98483,150500,403486,92211,836294,670954,1039963,364880,16091,515730,46447,268773,458989,247996,980072,628962,518299,927073,428443,151571,968103,949258,17998,497090,768738,396877,768107,491169,973243,202892,1031204,174853,334926,995771,203094,279907,838637,675413,128175,907338,698734,509749,1005866,704824,987232,832700,217272) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804484 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804484 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]