SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504545 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504545 [ RunTime:0.001979s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (972891,713208,619643,860404,723103,831690,907214,310702,43750,944417,106063,161545,539647,134189,820689,628979,86271,665474,294576,42168,841939,89418,459402,825541,522263,977322,565730,164071,1032556,180310,478824,677536,706440,115844,447145,388871,735170,583023,555941,491943,515585,183958,779006,43772,46895,481124,571477,371322,330236,1004461,728794,959422,228141,76422,89410,442545,60365,642039,385679,6137) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504545 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504545 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]