SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 551940 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 551940 [ RunTime:0.002313s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (347940,945896,109625,925840,447295,668079,580566,445677,742863,488005,510090,715858,628205,112431,327339,425837,289383,835395,153470,947979,166720,579362,3154,551509,363063,93405,544407,860692,438963,48722,315271,907062,584055,636107,755951,525411,381755,99105,1010537,392246,610257,924626,624162,8964,917253,429063,636697,567373,437671,862425,448393,886121,655540,1033378,163422,505907,848203,638478,73987,693425) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 551940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 551940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]