SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003691s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 205967 LIMIT 1 [ RunTime:0.002720s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 205967 [ RunTime:0.002014s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (531436,241892,1015615,153165,334600,14604,344650,206350,640573,220405,589452,13212,527038,47048,656571,487317,687529,413857,146669,880122,610795,964158,812920,1015401,965778,396672,609877,371694,810476,516919,802246,308164,1022115,150647,1001884,637223,819413,973703,629389,343821,358361,346814,505328,118451,429512,305251,847666,1040949,44741,233777,776673,1005460,656518,10917,385538,13943,417409,440644,397478,588484) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 205967 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 205967 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000701s ]