SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407540 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407540 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (818850,154472,210882,294732,682291,477801,847046,654613,911565,687981,114294,863159,277533,952400,51756,433550,593222,935599,873639,609847,344232,638857,411143,487190,959221,267726,402459,1045159,194190,208926,591457,742300,211988,159570,455585,613261,708912,99557,771542,692721,817925,806073,839267,993057,105398,9416,449534,478226,979698,651423,676750,762896,254935,523755,734814,290855,722749,571588,115659,940795) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]