SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105922 LIMIT 1 [ RunTime:0.002912s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105922 [ RunTime:0.005853s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (661909,152051,442170,412854,1015225,446657,477842,637657,735501,421006,658645,384686,139143,593750,266620,461836,453055,680492,455245,976906,476172,745923,2478,599596,422513,321984,377203,35362,752275,327377,150573,301480,393865,697147,723790,709198,301614,904141,882874,150895,846502,931552,471500,297822,814172,854035,599616,663197,719417,1018282,413207,1044598,755970,311692,147994,181809,455586,490120,395246,763321) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001721s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105922 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000636s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105922 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]