SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014080 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014080 [ RunTime:0.002050s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (568603,656620,431942,72192,576242,919883,5259,1015292,809048,245021,626083,22781,172614,206966,1020002,1038756,630180,396197,259271,526203,825074,818356,883663,462548,788122,937056,289411,409377,546796,559878,913970,116524,874411,217072,270172,151752,154231,951562,389839,474253,808849,640546,667772,160729,1012286,1024722,1023389,633676,5513,8651,200316,703761,541741,524089,499892,4297,993309,678142,537849,507269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003922s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002871s ]