SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504513 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504513 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022221,716409,788076,277593,375391,1030402,395235,652124,714739,300815,281601,16649,787970,169677,450435,483986,947829,152527,1042745,457786,491469,871567,150732,130265,28523,122345,209174,398942,228656,2352,614801,1015558,362848,764181,439258,873783,720303,705521,453268,1039281,358943,919898,367431,372512,671845,97252,51121,340667,924843,658598,235937,491817,33119,494721,263780,142447,69696,897247,400023,357701) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]