SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280505 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280505 [ RunTime:0.002094s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (564843,776420,246750,977653,392521,697677,41274,532028,467209,597808,312689,692213,130003,453401,231953,54153,729223,843165,770058,577393,90433,329843,462943,373364,442857,637437,335964,766075,728532,835139,575682,862816,485837,223557,135443,303985,81475,969559,835301,832388,17321,356866,363917,97084,352380,114039,89569,776340,821321,673746,581439,403699,105154,578847,1032862,807298,658817,941664,768342,325628) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280505 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280505 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]