SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 645403 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 645403 [ RunTime:0.002090s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (717703,136256,640689,913209,291212,360872,148019,46596,527447,923961,359191,277606,886028,644147,1019303,890242,696720,22097,471646,110832,293809,283085,403462,747014,188932,676768,742043,594398,862711,291595,827780,918150,878834,719444,133868,35670,1026152,518109,183382,951188,242510,174348,637796,292726,669823,641229,126672,427026,400878,12873,293285,359799,538194,526308,218700,86973,231418,459778,53340,762651) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 645403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 645403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]