SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 463409 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 463409 [ RunTime:0.002000s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (539448,862648,734234,251797,842343,603400,674423,297134,522250,694873,701845,423504,11468,160755,225978,279091,911337,590916,1029572,959914,1009889,1044859,350700,1001230,656028,334910,461942,948982,1009272,335372,186522,404299,120679,982064,669976,81219,454875,969741,95150,927416,709687,758957,556355,981760,898388,1015612,327260,828970,33685,144461,269159,339334,519627,587262,768897,885007,385261,489862,21082,191851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 463409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 463409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]