SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001685s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403846 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403846 [ RunTime:0.001874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (13363,950206,141979,1029279,280784,938626,196438,164728,173749,218527,491992,1019738,64511,838551,998331,15878,297786,835588,367759,989016,88874,330464,714478,97877,866443,889899,482921,569221,939315,896655,259990,386064,562277,709241,652323,527760,491288,198297,120803,718603,775749,772518,314423,992641,62769,860954,823348,232455,711614,301548,849394,661539,581573,636163,949041,609791,679943,900251,846040,885699) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.013683s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403846 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403846 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]