SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476941 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476941 [ RunTime:0.001549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (443206,285673,980510,510293,41950,895690,315455,194848,380211,577954,978605,264322,433383,52636,658235,25298,219234,838570,674893,739986,224741,731684,537069,835564,815601,664849,327460,252255,251996,416051,424822,631317,344373,121157,797173,187260,746150,856120,209067,177441,547997,317899,1000699,609693,610788,789598,805650,433153,986988,598535,840884,200512,908705,500367,721777,1037282,32712,713262,287195,982019) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]