SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447531 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447531 [ RunTime:0.002286s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419997,997174,1022315,121844,909501,800679,926366,945222,297399,884704,845121,234215,812186,7602,378912,493301,881050,269893,524853,210181,926946,149222,855074,651684,452034,5813,787639,466659,737564,50331,391075,78545,513006,495214,118055,786828,169550,406660,626414,635458,366253,635061,382206,206240,778551,884109,935189,145584,76233,125721,859370,223275,594772,552836,904141,932861,1029223,585363,354597,149599) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447531 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447531 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]