SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562082 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562082 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562842,353832,377121,923365,483409,348622,147364,96480,366763,145419,466711,830033,321874,743508,322232,311925,885652,906583,58735,44896,843738,978398,590877,152237,572984,729037,381384,325444,413452,812486,556557,301288,67,4504,948663,326271,385185,948041,479304,724953,64014,626679,1034555,755906,218647,972322,212453,881945,987916,323052,811424,640702,658962,388722,975930,3876,47437,697145,602817,1044853) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562082 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562082 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000761s ]