SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001735s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045567 LIMIT 1 [ RunTime:0.001032s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045567 [ RunTime:0.006352s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (182314,451077,52037,823210,722926,21611,539571,174685,704938,68789,733812,993468,585986,735980,279677,537479,466042,670754,859759,196915,285406,777148,255249,236552,395426,914323,192053,749754,316188,531160,1008122,238411,668519,230426,742978,528313,685349,262272,575504,564949,281902,711487,620736,879407,466715,934157,560864,120983,940987,845969,898621,869467,873020,908640,862893,736304,403534,281615,732428,15979) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006726s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045567 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045567 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]