SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407917 LIMIT 1 [ RunTime:0.000742s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407917 [ RunTime:0.003876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (103628,714906,359845,116547,574838,545341,77925,1011279,329056,582672,45295,279923,136042,951990,636135,94012,433683,552646,133262,695587,741294,511284,10479,1032390,1008506,430370,983886,515786,604182,1046031,112379,785996,988230,765602,920981,293035,449288,880024,783371,288656,853,500812,468095,780550,862541,498179,250819,354407,61473,399698,201283,820544,11853,854919,982437,244622,941771,794366,547090,337522) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407917 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407917 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002640s ]