SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030220 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030220 [ RunTime:0.002636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (546397,562672,603928,759572,778759,1013944,1033683,34490,386916,399282,845122,1000288,770323,696019,627419,376476,485574,176296,441445,209855,1002883,263097,586268,82204,69877,257648,666482,838228,991721,227736,150642,69698,533791,597488,575923,665858,372202,614176,588580,356476,58032,1039744,248371,72050,24296,798806,1002564,487828,224618,270225,269802,378916,936853,827932,682679,536945,120613,18102,19205,509985) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001588s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]