SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002380s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545632 LIMIT 1 [ RunTime:0.000832s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545632 [ RunTime:0.002621s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (961209,858936,634361,759380,78534,156323,37969,200784,663556,983512,268311,27315,644683,70415,519963,650035,377012,242306,423962,134094,10351,354434,179083,522193,858640,791168,76810,169233,22056,609503,296542,365926,72380,778000,940923,859952,602103,730977,1025599,493653,220217,58859,44196,704606,886690,201282,658090,1021487,1032934,147507,880173,482222,878850,22107,921513,244704,240185,902911,788157,888956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545632 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545632 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]